import asyncio

import hashlib
import hmac
import base64

async def main():
    org_id = "1"
    operate_status = "1"
    operate_time = "1"
    identity_code = "1"
    academy_code = "1"
    major_code = "1"
    uni_id = "1"
    isbn = "1"
    cover_image_url = "1"
    book_name = "1"
    book_author = "1"
    intro = "1"
    score = "1"
    ebook_url = "1"
    category_code = "1"
    category_lable = "1"

    if identity_code is None:
        identity_code = ""
    if academy_code is None:
        academy_code = ""
    if major_code is None:
        major_code = ""
    if uni_id is None:
        uni_id = ""
    if isbn is None:
        isbn = ""
    if cover_image_url is None:
        cover_image_url = ""
    if book_name is None:
        book_name = ""
    if book_author is None:
        book_author = ""
    if intro is None:
        intro = ""
    if score is None:
        score = ""
    if ebook_url is None:
        ebook_url = ""
    if category_code is None:
        category_code = ""
    if category_lable is None:
        category_lable = ""
    insertsql = "insert into uni_center.c_book_hot_1FE (org_id,operate_status,operate_time,identity_code,academy_code,major_code,uni_id,isbn,cover_image_url,book_name,book_author,intro,score,ebook_url,category_code,category_lable,version)"
    insertsql += " values('" + org_id + "','" + operate_status + "','" + operate_time + "','" + identity_code + "','" + academy_code + "','" + major_code + "','" + uni_id + "','" + isbn + "','" + cover_image_url + "','" + book_name + "','" + book_author + "'"
    insertsql += ",'" + intro + "','" + score + "','" + ebook_url + "','" + category_code + "','" + category_lable + "',3);"

    print(insertsql)





if __name__ == '__main__':
    loop = asyncio.get_event_loop()
    loop.run_until_complete(main())